gsm_category table — gsmca
This table is a multi-purpose grouping mechanism for generic entities. Certain categories might be system-owned or generated and cannot be deleted. These categories are usually hard-coded into your application.
Some categories might not be associated with another generic entity. These are used to store hard-coded valid value lists, lookup lists, and similar information. Whenever hard-coded mnemonics are used in the Progress Dynamics framework, their usage and description is defined in this table.
Table 14–1 lists the table’s FLA, fields, and foreign keys.
Table 14–1: gsm_category table information
|
Table FLA
|
Fields (data type)
|
Foreign keys
|
|
gsmca
|
category_obj (Decimal)
related_entity_mnemonic (Character)
category_type (Character)
category_group (Character)
category_subgroup (Character)
category_group_seq (Integer)
category_label (Character)
category_description (Character)
owning_entity_mnemonic (Character)
system_owned (Logical)
validation_min_length (Integer)
validation_max_length (Integer)
view_as_columns (Integer)
view_as_rows (Integer)
category_mandatory (Logical)
category_active (Logical)
|
category_obj
|
Table 14–2 gives details of the table’s indexes.
Table 14–2: gsm_category index information
|
Index name
|
Elements
|
Type
|
|
XPKgsm_category
|
category_obj
|
Primary Unique
|
|
XAK1gsm_category
|
related_entity_mnemonic
category_type
category_group
category_subgroup
|
Unique
|
|
XIE1gsm_category
|
category_label
|
Nonunique
|
|
XIE2gsm_category
|
category_description
|
Nonunique
|
|
XIE3gsm_category
|
related_entity_mnemonic
category_type
category_group
category_group_seq
|
Nonunique
|
|
XIE4gsm_category
|
related_entity_mnemonic
category_subgroup
|
Nonunique
|
|
XIE5gsm_category
|
related_entity_mnemonic
owning_entity_mnemonic
category_type
category_group
category_subgroup
|
Nonunique
|